get me output as if input is like
1 x o/p-->1 x,y,z
1 y 2 a,b
1 z 3 c
2 a
2 b
3 c
No Answer is Posted For this Question
Be the First to Post Answer
how to move the mappings from your local machine to claint place?
explain abt union t/r?
What is rank transformation?
write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6
What is the Rankindex in Ranktransformation?
my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer
What is confirmed dimension with scenario
How will you update the row without using update statergy?
suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<=5 then what will be the output?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.
How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Trans).