How IN function works in informatica? Is it similar that of
oracle IN function or different? Explain
Answers were Sorted based on User's Feedback
I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .
can anyone explain me about retail domain project in informatica?
Can anyone tell me the new features in Informatica 9 Version?
Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?
Can a joiner be used in a mapplet.
draw informatica architecture 8.6 ?
what is distinct
Which development components of informatica have the highest usage?
how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.
explain abt union t/r?