Interested to Buy Any Domain ? << Click Here >> for more details...
without matching columns in two tables. how can you join
- 5 Answers
- 11504 Views
- BirlaSoft, I also Faced
- E-Mail Answers
Answer Posted / sarthak
U can't join two tables (without matching columns) through
UNION T/f.It requires matching columns for UNION.
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
What will be the approach?
What is a shortcut and copy in Informatica and how two are different with each other?
server hot-ws270 is connect to Repository B. What does it mean?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
What is rank index in rank transformation?
How to convert multiple rows to single row (multiple columns) in informatica
What does cheating measurement mean?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are the types of caches in lookup?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Performance tuning in UNIX for informatica mappings?
Do you find any difficulty while working with flat files as source and target?
What is fact table? Explain the different kinds of facts.
How does a rank transform differ from aggregator transform functions max and min?
