Interested to Buy Any Domain ? << Click Here >> for more details...
what are the different types of transformation available in
informatica and what are the mostly used ?
- 3 Answers
- 25159 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
Lookup,Expression,Rank,Sorter,Agreegator,Update
Strategy,Filter,Router,Source Qualifier,stored
Procedure,Sequence generator and joiner.
The mostly used transformations are :
Lookup, Expression, Agreegator,Router and Update
Strategy,joiner and sequence generator.
sumi..
| Is This Answer Correct ? | 20 Yes | 5 No |
Answer / sailaja
Look up,Expression,update
strategy ,joiner,router,filter,sequence generator,
aggregator,normalizer,stored procedure, webservice
transformation,XML generator, XMLparser,source qualifier
Mostly used transformations are
1.Look up, Expressions
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / bharathi
Lookup,Expression,Rank,Sorter,Agreegator,Update
Strategy,Filter,Router,Source Qualifier,stored
Procedure,Sequence generator and joiner,Update
Strategy,Normalizer,XML source qualifier.
| Is This Answer Correct ? | 5 Yes | 6 No |
If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?
source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Is snow flake or star schema used? If star schema means why?
How to delete duplicate record in Informatica?
i have one table like cust_id ph1 ph2 ph3 1002 9290123526 97671927210 9876545232 we use Normalizer wt is o/p? sue normalizer we can generate three tables in single table/
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance
write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5
what type of transformation is not supported by mapplets?
what is data driven in informatica
what is the size of u r source(like file or table)?
what is the drillup & drill down?and use of the drill up and drill down?
Teradata 
