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 are the deliverables?in your project?
What are the different transaction levels available in transaction control transformation?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is the use of transformation?
In informatics server which files are created during the session rums?
What are batches?
How many types of sessions are there in informatica.please explain them?
Enlist the various types of transformations.
What are the prerequisite tasks to achieve the session partition?
What is the sql query overwrite in source qualifier in informatica
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is the difference between source qualifier transformations source filter to filter transformation?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is a mapplet/worklet in informatica?
Design a mapping to load the cumulative sum of salaries of employees into target table?