we have table like cust_id,cust_name,cust_loc like this
1.we need to get perticular location,to do this we can use
filter transformatin,that logic is same for relation table
and flat file tabl?
Answer Posted / sreenu
yes
but if it is a relational table beter to use SQL overried
for performence
for flat files u have to use filter t/r
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is meant by target load plan?
Why do we need informatica?
What is the advantage of informatica?
How to configure mapping in informatica?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Could you explain what is enterprise data warehouse?
What are junk dimensions?
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
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
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.
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
How to go to the older version for a mapping?
Which development components of informatica have the highest usage?