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
Answer Posted / ankit kansal
please elaborate your question...
Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What is a passive transformation?
Difference between Target-based loading and constraint-based loading?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is a sorter transformation?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Explain lookup transformation in informatica
How to update a particular record in target with out running whole workflow?
What does “tail –f” command do and what is its use as an Informatica admin.
How do you set a varible in incremental aggregation
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
expain about the tune parameters?
What do you mean by filter transformation?
what is the -ve test case in your project.
Difference between Data and Index Caches?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.