If you done any modifications for a table in back end does
it reflect in informatca warehouse or maping?
Answers were Sorted based on User's Feedback
Answer / deepak aggarwal
No there is no option in informatica for automatic update
of source/target/lookup/stored procedure definition from
DB/file.
Though you can compare source/target/../.. definitions from
existing DB objects and make out if informatica definitions
needs a updation.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / janardhan avula
No..it could not reflect in informatica.informatica is one
of the Dynamic ETL tool using this tool we can design the
the data effectively according to business
requirement..database is different..
I though am i correct.
if u want more info mail me at avula.janardhan@gmail.com
Is This Answer Correct ? | 0 Yes | 0 No |
what is distinct
What are active and passive transformations?
How would you join a node to the already existing domain?
How do u identify or filter out a 0 byte file available in a folder by using UNIX command?
What are the different lookup cache(s)?
What are the differences between a connected lookup and unconnected lookup?
Where are the source flat files kept before running the session?
What are the disadvantages of Sequence Generator T/R?
what is metadata?
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.
I have source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000