My source data is :
ID TimingID Timingtype 1 100 supplier 1 102 dealer 1 103 dealer 2 200 xyz 2 205 abc
I want my target to be like this : ID T1_TimingID T1_Timingtype T2_TimingID T2_Timingtype T3_TimingID T23_Timingtype 1 100 supplier 102 dealer 103 dealer 2 200 xyz 205 abc null null
Kindly suggest.
Regards Sandeep Nanda
I have a Time column in my SQL Server table which has data like (14:00:00.0000000).
I am trying to load this type of data in Oracle table which has corresponding column datatype as timestamp. I am trying to convert the time column in SQL server to timestamp column in oracle using Informatica.
Whats the best way to do it?
I have a scenario wherein the data is present in just single row. with multiple columns. The number of columns may extend if new record is inserted.
name city name city name city name city...... N1 C1 N2 C2 N3 C3 N4 C4.....
i want to write the output of this data to a fixed width flat file through informatica like below:
N1 C1 N2 C2 N3 C3 N4 C4
Please suggest..
how to convert single to multiple columns, please any body know this answer please tell me, if you have video send me please
I have a source with multiple columns - minA, maxA, minB, maxB, minC, maxC, minD, maxD
and I have 2 columns in target min values, max values. How can i put the min values of elements in min values of target and same with max?
