If the values in a row are 1,2,3,3,4,,4,5 then how a rank
transformation can rank these values
Answers were Sorted based on User's Feedback
Answer / kondeti srinivas
explanation for sam.
sam has given currect ans 1,2,3,3,5,5,7
upto 1,2,3 is fine after 3 again itput is 3 for that rank
t/f give rank as 3 after rank t/f skip 4 ranks becasue it
already given rank for repeaded value and for null values
it rank will not give any rank
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / nitin
Rank transformation in informatica is like rank() function in oracle. that's why it's giving the next value after the repetition of some values.
Is This Answer Correct ? | 0 Yes | 0 No |
I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?
In which situation we will use persistant cache and shared cache in real time. plzsss answer with example
how the informatica server sorts the strings values in rank transformations?
Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3
Differentiate between router and filter transformation?
I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?
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?
how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?
If we are using an aggregator but forget to mention the group by port .what will be the output??
Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer
What is DR strategy for Informatica project?