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 |
my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.
What is rank transformation?
What are different types of transformations available in informatica?
What is primary and backup node?
How to load duplicate records in to a target table which has a primary key?
How will you combine 3 different sources with a single source?
Why should we use star schema in datawarehouse design?
Performance wise which is better joiner or look up ? Give me with example?
How would you copy the content of one repository to another repository?
Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance
Under what condition selecting sorted input in aggregator may fail the session?
without using rank transformation how can we rank items by using some other transformations