If i done any modifications for my table in back end does it
reflect in informatca warehouse or maping desginer or source
analyzer?

Answer Posted / swetha

NO. Informatica is not at all concern with back end data
base.It displays you all the information that is to be
stored in repository.If want to reflect back end changes to
informatica screens, again you have to import from back end
to informatica by valid connection.And you have to replace
the existing files with imported files.

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to configure mapping in informatica?

674


How do you set a varible in incremental aggregation

1446


What is persistent lookup cache?

603


What are active and passive transformations?

652


How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

709






Please let me know how to make Data masking in informatica..

1269


How are the sources and targets definitions imported in informatica designer?

670


What is the difference between stop and abort in informatica

663


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

3450


What are the basic requirements to join two sources in a source qualifier transformation using default join?

611


what is degenerated dimension?

3153


what is SDLC way of code development?

1559


How to start a workflow using pmcmd command?

713


How can a transformation be made reusable?

665


Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1536