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
what is informatica metadata?
What is the scenario which compels informatica server to reject files?
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
How to generate or load values in to the target table based on a column value using informatica etl tool.
Explain the use of aggregator cache file?
On which transformations you created partitions in your project?
What is a difference between complete, stop and abort?
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??
what is diff b/t sorter t/r and agg have the option sorter property...
Enlist the tasks for which source qualifier transformation is used.
pmscmd startworkflow -sv
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
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.
What are the types of schemas we have in data warehouse.
What the difference is between a database, a data warehouse and a data mart?