Interested to Buy Any Domain ? << Click Here >> for more details...
How to load last 10 records of flat file in to the target?
- 5 Answers
- 25025 Views
- iNautix, I also Faced
- E-Mail Answers
Answer Posted / koti
sequence generator, rank transformation.. in rank
transformation write the condition 20 ranks, bottom to top..
| Is This Answer Correct ? | 11 Yes | 5 No |
Post New Answer View All Answers
Write the unconnected lookup syntax and how to return more than one column.
What do think which one is the better joiner or look up?
Is it possible to define a single node as a Gateway node as well as worker node?
What are ETL Tools?
How can we update a record in the target table without using update strategy?
What is the benefit of session partitioning?
According to his methodology what all you need before you build a datawarehouse
Can we change Dynamic to Static or Persistent cache? If so what happens?
EXL informatica Questions
How do you remove duplicate records in informatica? And how many ways are there to do it?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
How can we remove the duplicates from flat file source?
What is a code page?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
