how can we load starting with 11th record of a table from
source to target
Answer Posted / krish
take expression in exp take variable port(v1.......v1+1)and
take output port(in that give v1)send this o/p port to
router give the condition as v1>11.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Explain sessions?
What is fact table? Explain the different kinds of facts.
What is the use of an aggregator cache file?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
difference between repository database and repository service?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the mapping parameters and mapping variables?
What is an Integration service in Informatica?
What is the difference between writing a joiner query in ANSI style and THETA style?
What is pmcmd command?
Briefly explain the aggregator transformation?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?