DSXchange

Thank you for your reply Poorna.I will try this. Hi Rakesh, I found a solution to your query: SRC--> Transformer --> TGT In Transformer : Stage Variables -> svar1 : If IsNotNull(DSLink2.COL) then svar1:',':DSLink2.COL else svar1 svar2 : LastRow() Constraint : svar2 output column = svar1 Output : 1,2...

Hi Chulett, Thank you for your reply. I tried using Lastrow() function, But my approach is not working. where exactly we have to use this LastRow() function in the derivation. I tried solving this with below two methods,but I didn't get the desired output.Can you please let me know how to achieve th...

that's my mistake.yes its for all records.

No. It should not be 4 output records. Suppose, If there are 20 records then output should be one record with one filed as (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20)

Can any one please explain how to achieve this scenario in datastage using transformer? Input ColA 1 2 3 4 5 Output ColA (1,2,3,4,5) there is no common key in the input 5 records.Since there is no common key,I think like we cannot use lastrowingroup() function in transformer. I tried like this but i...

I just started working on IBM Infosphere DataStage and Quality stage version 11.7. I am looking someone will give me one to one training in my real-time situation. if anybody interested please send me a personal email message. Thanks. You can also try this. Learnquest.com. IBM training partner. htt...

Suppose if i want to load the metadata in sequential file at source stage, I will import the metadata from the table definition and load it into the sequential file stage, but I dont understand here while loading, what is the use of enabling the rcp option? what happens if we dont enable it.

From your points I understand that we cannot read a file from oracle connectorstage or anyother database connector stages. We can read the file from only filestages like sequential file stage. If we read only from sequential file stage, then why we have to enable the run time column propagation and ...

Yes.

Hi Chulett/qt_ky

I tried using the looping variable @looping <=5 in transformer stage and assigned the input record to this looping variable and I got the ouput as below. thank you all for your inputs
thanks
Rakesh

Hi Chulett,

Here the source is only files, All these source files have different schemas.
But we have to read the files using the Oracle connector stage and load into target DB2 tables.

Thanks
Rakesh Puli

What is the logic we have to apply to avoid using two transformers and copy stage? To use only one transformer and output to two targets and job design should look like this.

Thanks
rakesh

Hi I have designed a job to remove duplicates using the key change column in sort stage. I have written the records with the key change value=1 into target1 file with constraint "keychange value =1" in transformer and other records key change column value=0 with constraint in transformer w...

Hi I have a requirement as below, I have to achieve the output like the below. how I can do this with the @iteration variable in transformer and what derivation i have to give in the stage variable and looping variable.Please help me with this Input record 123 Output 123 123 123 123 123 Thanks Rakesh

Hi

I have a requirement like to load 50 DB2 target tables from 50 Oracle source tables or source files with different schemas with only using source as Oracle connector stage.

How can I achieve this? Please let me know.

Thanks
Rakesh