Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?
Answer Posted / rakesh
What if A and B eixist in different Databases..?
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Enlist the differences between database and data warehouse.
State the limitations where we cannot use joiner in the mapping pipeline?
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 fact table?
What is a joiner transformation?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
How do you remove duplicate records in informatica? And how many ways are there to do it?
How would you join a node to the already existing domain?
Quickly characterize reusable change?
Can we create a Integration service without a Repository service and vice versa?
What is an active transformation?
How to generate or load values in to the target table based on a column value using informatica etl tool.
expain about the tune parameters?
What are the tuning techniques you applied during your last project
What is the sql query overwrite in source qualifier in informatica