Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)
Answer / isha
Among these three, you can only use seq generator (only reusable sequence generator)
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain the etl program with few examples.
i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?
What are two types of processes that informatica runs the session?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is blocking transformation?
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
How can u stop a batch?
can you avoid static cache in the lookup transformation? I mean can you
what is rank and dense rank in informatica with any examples and give sql query for this both ranks
Hi Every One,What is Use of Factless Fact Table ? Why we use Factless Fact Schema in the Projects waiting for reply? thank you
Tell me about informatica architecture.
empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.