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 |
If we set dd_insert in mapping and Delete in session properties what will happen.?
Explain the mapping variable usage example in informatica
Define Incremental Aggregation?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What are the different options used to configure the sequential batches?
how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?
difference between top down(w.h inmon)and bottom up(ralph kimball)approach?
what is the method of error handling when session is running?
what is confirmed fact?
What is the format of informatica objects in a repository?
suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer
What is hash partition?