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
- 5244 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 |
Explain in detail about scd type 1 through mapping.
How can you generate reports in informatica?
What are the different lookup cache(s)?
Scheduling properties,whats the default (sequential)
i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z
wt is informatica file watch timers in aflat i want to get the first record and last record how could i.
State the limitations where we cannot use joiner in the mapping pipeline?
Is it possible to revert a global repository to local one and why?
Explain about HLD and LLD ?
How to elaborate tracing level?
What is main use of mapplet?
i have 2 session s1 execute s2 load first session fail what is the reason?
Teradata 
