Interested to Buy Any Domain ? << Click Here >> for more details...
i having mapping
emp---> sq_emp--->target
using this mapping i have to load dept table values into
target... (condition assume there is no primary and foreign
key relation between emp(table x) and dept (table Y))
- 5 Answers
- 9713 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / snjsngh15
Based on the constraint based load we can load the data IT means emp table in target t1 and dept in target t2.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the differences between a connected lookup and unconnected lookup?
Explain the mapping variable usage example in informatica
Explain where to store informatica rejected data? How to extract the informatica rejected data?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Why update strategy and union transformations are active?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
How might you approve all mappings in the archive all the while?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is the difference between router and filter?
Explain the tuning lookup transformation - informatica
Explain the shared cache and re-cache?
I have a flat file, want to reverse the contents of the flat file
What is the use of code page?
How we can create indexes after completing the load process?
r u done any partitions in ur project?
