Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / kaki
Look up transformation is used for looking up a value from
OLAP table within a mapping before populating it. For
example, I have empid and I want to get emp name to use in
the next transformation, I would search for it in a look up
table which has the emp name by giving input as emp id.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.
how many steps are there in etl process?
Explain and compare etl & manual development?
what is the use of structures?how many nodes can u create in a structure?
please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance
what are the types in error loging?
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
What is virtual Data Warehousing?
what are the data modeling tools you have used?(polaris)
What is partitioning? Explain about round-robin, hash partitioning.
What is a mapping, session, worklet, workflow, mapplet?
What do you understand by active and passive transformations?
