If the values in a row are 1,2,3,3,4,,4,5 then how a rank
transformation can rank these values
Answer Posted / sujana
rank
1 1
2 2
3 3
4 4
4 4
5 6
Is This Answer Correct ? | 8 Yes | 12 No |
Post New Answer View All Answers
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What are the components of the workflow manager?
What is the difference between Active and Passive transformation?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Mention few power centre client applications with their basic purpose?
How do you load unique records into one target table and duplicate records into a different target table?
Write the different tools in the workflow manager?
How are indexes created after completing the load process?
What is dimensional table? Explain the different dimensions.
What are the different clients of powercenter?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
How do you use reject loader.
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??