Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6105 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 |
What are the basic needs to join two sources in a source qualifier?
How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)
In operator is used in which transformation in informatica 8.6.0
Hi All can anyone tell me where i will get Informatica training in Mumbai?
How to calculate the cache size if say we are doing a performance check on a mapping and found that a particular cache needs to be changed. Is there a formula to calculate this! i know that informatica has a auto option available but how to calculate manually?
how to declare array in plsql?
What are the Differences between static cache and dynamic cache?
i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81
As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?
what are the difference between Informatica 7.1 and 8.1?
write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste
Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks
Teradata 
