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?
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 |
enterprise datawarehouse your project phase by phase explain?
What is meant by lookup transformation?
What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.
Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks
If we are using an aggregator but forget to mention the group by port .what will be the output??
Explain the use of aggregator cache file?
What are the different options available for update strategy?
What are the different lookup cache(s)?
in reporting we add some new objects,how we get the count of the newly added objects to the report
what is the difference between repository & Intergration service
Can we write to_date(three arguments) ? Will it work ? Advance thanks
What is incremental aggregation and how it is done?
8 Answers JPMorgan Chase, TCS,