Answer Posted / swetha
BY using Pivot stage convert rows into columns in
datastage.If we want to change in informatica we use
normalizer transformation.
| Is This Answer Correct ? | 11 Yes | 6 No |
Post New Answer View All Answers
Describe the architecture of datastage?
Name the different sorting methods in datastage.
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What are the main features of datastage?
Why do we use link partitioner and link collector in datastage?
What a datastage macro?
Explain the importance of surrogate key in data warehousing?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
Explain connectivity between datastage with datasources?
Can we use target hash file as a lookup ?
What are the repository tables in datastage?
Notification Activity
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
What is the sortmerge collector?