If you done any modifications for a table in back end does
it reflect in informatca warehouse or maping?
- 2 Answers
- 5567 Views
- I also Faced
- E-Mail Answers
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 |
get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c
Enlist the differences between database and data warehouse.
can every transfomation reusable?how?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
what type of problem you faced insales project or insurance project
What is the difference between informatica 7.0 and 8.0?
what is the predefined port in dynamic lookup
case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,
When will you use SQL override in a lookup transformation?
Is it possible to use a client with different version than that of its Informatica server?
If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?
What is the use of transformation?
Teradata 
