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 are the parts of Informatica Server?
In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?
IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?
Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com
What is meant by pre and post session shell command?
What does cheating measurement mean?
how many ways can we implement SCD2?
When you move from devel to prod how will you retain a variable
Explain the informatica workflow?
source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.
Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?