DSXchange

I cannot see any data.... where in the job log will i find the data... i dont want the number of rows... i need to look into the data


thanks
aschand

Can any one please tell me how to see data that is in Peek stage as target.... there is no option called view data... So how do i see the data using peek stage.

thanks
aschand

There is a source file and a look up file. Now i need to process only those rows from the source whose key column values match with the lookup file column values. Only those few rows have to be populated in the target. Im using source as SQL server stage, A seq file for look up and a SQL Server stag...

My question that how do we populate a single table with more than 1 job

There are 3 different jobs that need to be loaded in a single table... is there a way to run all these three together to populate the table.

Can any one please tell me how to run more than 1 job at the same time to load into a table.


thanks
aschand

Yes what you said is somw what yes. But my question is what is meant by adding a check in ETL job for that particular column where we find the value as "GT"

Add a check to the ETL job, if Legacy_ID starts with "GT" and MLAN_ALAND = null for that part, also let this condition add an additional MAKT row for SPRAS of "L", using the MAKT_MAKTX_PL for the description value.


please help me how to write the logic


thanks
aschand

i saved it as .csv file... then how do i do the rest of the thing

thanks
aschand

Please can any one help me in creating a table definition for a spread sheet data....

I do not know the procedure.

Thanks
aschand

I have created a job in which i used join stage... Now i have to change the joins of the input files if file 1 has left outer join on now i have to make that intermediate and make file which is intermediate before as left outer join now. please help me on this how to change it... i tried to replace ...

thanks... it got solved

Can any one please help me with this issue the data in the source for a column is '1234566777888' (stored as character) but in the target table it is stored as '1234566777' only i.e; accepting only upto 10 characters other columns with same data type are able to handle large values bigger than this....

Hii I could not see the properties tab for any stage in the job. It is in inactivated mode.

Why is that so... the job is working perfectly... but now it is in inactivated mode.... how to make it to activated mode?


thanks for ur help
aschand

Sorry!... But i could not get any information there... Can you please let me know the answer..

thanks
aschand

HI

Can any one please tell me if the key field which identifies the duplicates in the Remove Duplicate stage can be NULL?


Thanks
aschand