Without using any transformations how u can load the data into
target?
Answers were Sorted based on User's Feedback
Answer / soujanya
with out using any transformation we can directly load the
data to target this is known as SIMPLE PASS MAPPING. when
we drag the source to workspace the source automatically
generates source qualifier and from source we can connect
to target. In case of cobol files we use the normalizer
transformation. and remember source qualifier is also a
transformation rite.
soujanya mentay
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / shiva
simply connect source to target
but be very careful with the connections from source to
target
| Is This Answer Correct ? | 4 Yes | 5 No |
Answer / sree
at the time of draging source in to workspace it will auto
matically genartes sq t/r from this u connect to target
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / suren
yes it possible without using any transformation ,mappinf from sq to target .
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / gaurav rustogi
Simply connected souce with target.
If any condition is there we can put in the Source Qualifier
| Is This Answer Correct ? | 1 Yes | 4 No |
What are the different types of code pages available in informatica & how to implement it in your project?
How to load only the first and last record of a flat file into the target?
write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3
What is dimensional table? Explain the different dimensions.
tell me the informatica architecture
Useful UNIX commands regular/frequently used
How can we update a record in the target table without using update strategy?
what is the difference between static and dynamic
Performance wise which is better joiner or look up ? Give me with example?
What is the difference between stop and abort in informatica
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?