If i done any modifications for my table in back end does it
reflect in informatca warehouse or maping desginer or source
analyzer?
Answers were Sorted based on User's Feedback
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 |
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 |
Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.
How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????
What is Collect performance data in informatica and what is the use of it.
what is the significance of newlookup port in dynamic look up
i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What are the circumstances that infromatica server results an unreciverable session?
I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution
Can a joiner be used in a mapplet.
What is resilience time?
How mapping parameter and variable works
how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)