Flat file heaving 1 lack records and I want to push 52000
records to the target?
Answer Posted / tadikonda
IF IT IS A FILE
Take one variable with the name $$count at mapping variable
level
Mention the initial value for that $$count=0(For every
record it will increment the count value by 1)
source-sq-Expression-Filter-Target
in that expression just take one o/p port in that
o_count=SetCountVariable($$Count)
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Explain sql transformation in script mode examples in informatica
Is there any way to read the ms excel datas directly into informatica?
Explain the scenario which compels informatica server to reject files?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Why update strategy and union transformations are active?
What is meant by pre and post session shell command?
Differences between version 7.x and 8.x.
Describe the impact of several join conditions and join order in a joiner transformation?
What is incremental aggregation?
How do you set a varible in incremental aggregation
How do you load only null records into target?
What is target load order?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
How can we create index after completion of load process?