How many number of sessions that u can create in a batch?
- 3 Answers
- 9273 Views
- I also Faced
- E-Mail Answers
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 |
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
What are the main issues while working with flat files as source and as targets ?
What does command task mean?
What are the active and passive transforamtions?
I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have, source having 10records. Same with incrementally. Please answer me ASAP.
how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.
I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?
Explain the informatica workflow?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?
What is workflow variable? When we use workflow variable? Can any one explain me with one example???
Teradata 
