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
- 5278 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rahul
You can write the SQL statement for that particular
location in the source qualifier if it is a relational
table.
Use Filter if it is a flat file.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
how can we calculate fact table size?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix.
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is meant by active and passive transformation?
What is the role of informatica in project ?Like i showed financial projects?
how many repositories can v create in informatica .
3 Answers Cap Gemini, Tech Mahindra,
tell me 7.x and 8.x diferrencess(but not transformations)
What is the Rankindex in Ranktransformation?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the new features of Power Center 5.0?
What is the Difference between SetVariable and setmaxvariable in informatica?
What are mapping parametres and variables in informatica?
Teradata 
