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?
- 2 Answers
- 5503 Views
- I also Faced
- E-Mail Answers
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
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is the reusable transformation?
How many types of sessions are there in informatica.please explain them?
How can repository reports be accessed without sql or other transformations?
What are the settings that you use to configure the joiner transformation?
How to create or import flat file definition in to the warehouse designer?
Explain the etl program with few examples.
Explain joiner transformation in informatica
What is a rank transform?
Describe an informatica powercenter?
How can we handle two sessions in informatica?
How to configure mapping in informatica?
How to extract the informatica rejected data?
How will the document be delivered to me?
