1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / swetha

Answers were Sorted based on User's Feedback



If i done any modifications for my table in back end does it reflect in informatca warehouse or map..

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

If i done any modifications for my table in back end does it reflect in informatca warehouse or map..

Answer / puli ramesh

The Informatica Repositoy will have already an imported
tables and if changes been done at backend is concerned
tables. Untill it is Re-import the tables from the database
then changes will be reflected.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More Informatica Interview Questions

I have scenario, i have 10 worklflows and i want run the 1st workflow first and immediately i want to run 10th workflow has to run and am not bothering of 2 to 9 workflows? can any one help me how to do this? Thanks in advance.....

4 Answers   Patni,

WHAT IS THE DIFFERENCE B/W 7.X AND 8.X ? TELL ME FEW DIFFERENCES.

2 Answers  

What is the function of aggregator transformation?

0 Answers  

I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,

3 Answers   CSC,

What is substr in informatica?

0 Answers  




Explain incremental aggregation in informatica

0 Answers   Informatica,

write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15

5 Answers   Tech Mahindra,

Explain target update override in informatica

0 Answers   Informatica,

without using rank transformation how can we rank items by using some other transformations

2 Answers  

Enlist the tasks for which source qualifier transformation is used.

0 Answers  

What are the basic needs to join two sources in a source qualifier?

4 Answers  

What do you mean incremental aggregation?

0 Answers  

For more Informatica Interview Questions Click Here
Categories