Interested to Buy Any Domain ? << Click Here >> for more details...
How to jion 2 tables, without using any condition?
- 11 Answers
- 37697 Views
- Amazon, I also Faced
- E-Mail Answers
Answer Posted / raj
Add dummy column in expression or Source Qul. for both
source and use that column in join condition.
| Is This Answer Correct ? | 12 Yes | 4 No |
Post New Answer View All Answers
what is mean by complex business rule ?
What are pre and post-session shell commands?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Why do you use Mapping Parameter and mapping variable?
where to store informatica rejected data?
Explain lookup transformation is active in informatica
Which files are created during the session rums by informatics server?
How do you use reject loader.
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Explain the use of aggregator cache file?
What is an expression transformation in informatica?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What are the static cache and dynamic cache in informatica?
