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 |
If I have a index defined on target table and if set it to bulk load will it work ?
How do you create single lookup transformation using multiple tables?
What is the functionality of update strategy?
Name the different lookup cache(s)?
can we use cartesian join in informatica
I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..
Write the program through which the records can be updated?
What do think which one is the better joiner or look up?
who to split dimentions into sub dimention
Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.
In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar
Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve