If you done any modifications for a table in back end does
it reflect in informatca warehouse or maping?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is informatica metadata?

574


What is the scenario which compels informatica server to reject files?

579


Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

3407


How to generate or load values in to the target table based on a column value using informatica etl tool.

590


Explain the use of aggregator cache file?

646






On which transformations you created partitions in your project?

738


What is a difference between complete, stop and abort?

616


IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

534


what is diff b/t sorter t/r and agg have the option sorter property...

1712


Enlist the tasks for which source qualifier transformation is used.

564


pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1023


i have a data in my source as a flat files what test i have to perform the next step can any body help to me

1682


how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1228


What are the types of schemas we have in data warehouse.

507


What the difference is between a database, a data warehouse and a data mart?

571