While using update strategy in the mapping which gives more
performance, a flat file or Table? Why? What are the
advantages and disadvantages?
Answer Posted / kish`
hi,
update strategy never use for flatfiles....plz correct me,
if it is wrong
| Is This Answer Correct ? | 14 Yes | 1 No |
Post New Answer View All Answers
What is a repository manager?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
As union transformation gives UNION ALL output, how you will get the UNION output?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
whats the logic to load the lower level of granularity of data to fact table.
How to differentiate between the active and passive transformations?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
How might one distinguish in the case of mapping is right or not without associating session?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is the need of etl tools?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What do you understand by SOA of Informatica?
Can we create a Integration service without a Repository service and vice versa?
How to load a Dimension ? and how to load a fact table?