How many number of sessions that u can create in a batch?
Answers were Sorted based on User's Feedback
Answer / bala govi
I dont see there is a limit set for number of tasks that
you can have it in workflow/batch. but best practice is to
have less number of tasks this will help especially during
migration.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ravi
At a time informatica server can execute 30 sessions
parallelly.
| Is This Answer Correct ? | 1 Yes | 2 No |
what is data driven?
Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?
In real time scenario where can we use mapping parameters and variables?
what is session override?
Why we select the table which has minimum number of records as Master table in joiner?
what is the flat file partition and where have to specify it
Define the various join types of joiner transformation?
How can yoU create or import flat file definition in to the warehouse designer?
i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.
Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.
How IN function works in informatica? Is it similar that of oracle IN function or different? Explain
can any one explain me about junk dimension