How to display null values on a target & non-null values on
a target?
Answers were Sorted based on User's Feedback
Answer / ramesh.b
hi,
normally router means multiple targets...take 2 groups first group condition isnull and second group condition not isnull.first group gives the null values and second group gives the non null values.
source-->sq-->expression-->router-->2 targets
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / murugan
normally router means multiple targets...first taget display
the null valuesw and another records display the non null
values..
| Is This Answer Correct ? | 3 Yes | 1 No |
Explain pushdown optimization $pushdownconfig parameter - informatica
Explain load alternative records / rows into multiple targets - informatica
Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What aer the out put files that the informatica server creates during the session running?
what are the perameter and variable?
Why use the lookup transformation ?
what is the diff b/w target load plan and cbl?
to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?
What are the tasks that source qualifier perform?
Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)
can anyone suggest best free Talend data integration training online