DSXchange

Hi Gurus,

I have worked with lookup transformation, but never came across connected and unconnected lookup.Where does we use such type of transformation.

cheers;
Vijay

Hi Gurus,
Sorry i have given incomplete information. I was asking for common error handling techniques. Generally i go for only check points, are there any other ways .

cheers;
Vijay

Hi Gurus,
Actually my team lead was asking me how to handle in such cases.
I said generally we go for check points, check points acts as intermediate stopping pt which helps from failures. I wanted is there any other way to handle.

cheers;
Vijay

Hi Gurus,
I have designed a sequencer and scheduled that sequencer at night.

Iam getting error in my sequence.Can you please help me with the techniques to handle the sequencer which has aborted at uneven times.


cheers;
Vijay

Hi Gurus,
The default size of hash file is 2 Gb. Can we increase the default size. If so can anyone specify the steps the default size.

cheers;
Vijay

Hi,

I never handled when the data is in XML format. Can anyone help me out, with the ways how to handle the xml i/p's.

cheers;
vijay

Hi, My source data has pogtype pogstatus customercode effective date Another table has columns pogtype customer code. I need to compare the pogstatus.if the pogstatus is the same, I neednot do anything, only if the pogstatus is different I need to update the effectivedate and insert. cheers; Vijay

Hi,

Version control helps in migrating the datastage jobs from dev to testing environment.

Can Gurus help me out with the steps for migrating the datastage jobs .

Not with the version control, i means before we make use of version control what are the steps in development env

cheers;
Vijaykumar

Hi Gurus,

Can anyone help me out with the process how data is migrated from development to testing env.One of my friend said that they make use of version control.please gurus help me in understanding the migration.

cheers;
Dileep

Hi Gurus,

Actually my team mates were asking me that besides two types of dimensional models like star schema and snowflake there is also another model, can gurus help me out .
I just want to analyze.

cheers;
Vijay

Hi Gurus,

In the incremental loading, we consider loading records b/w the last successful load and current record.

Actually i have never done incremental loading.How do we know the last successful load.

Can Gurus plz help me in analyzing.

cheers;
Vijay

Hi Gurus; Is it possible to dump the data from odbc to odbc. odbc--->odbc. without any transfomation in between the two stages.I tried out its throwing error. It doesn't recognise the table name, even if i choose in the target update action as create new table, its throwing error. please help me. ch...

Hi Gurus, My Design is Hashfiles---->UniVerse Stage while defining the universe(uni) datastage properties.Iam facing lot of problem. Its asking for database connection name, user name and password. I gave the dsn name, user name as scott and password as tiger, since iam connecting to oracle. In deta...

Hi Gurus,
One of my friend has exported me few jobs, i dont know the version he is using, i rang him he is out of station.I imported these jobs, is there any way i can find the version of Datastage he is using.


cheers;
vijay

Hi,
I think the latest version of datastage is 7.5.1, one of my friend is saying that there is also version called 7.5.2 , is there any difference between the two. What is the latest version now.

cheers;
vijay