how can you load data into target table without leading zeor's
Answers were Sorted based on User's Feedback
Answer / srini
By using the Trim function we can able to Remove the
leading Zero's in a value and we can load it in to target.
Function : trim(Col_Nm,'0',L)
Is This Answer Correct ? | 12 Yes | 2 No |
Answer / sai
Use Exp transformation and use function
Ltrim(col_name,'0')
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / abhinaw prakash
We can use Replace function as well to remove the zeroes
before loading the data into the target
Is This Answer Correct ? | 0 Yes | 7 No |
How to convert multiple rows to single row (multiple columns) in informatica
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
can we use bulk loading when we use look in mapping
How to update source definition?
If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?
What are the types of lookup transformation?
What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?
how to connect two or more table with single source qualifier?
How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.
I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
Hi, I have one scenario.. i want to insert 4 times (Duplicate) a row in the target. Please help me . source row: abcabc Tgt table: abcabc abcabc abcabc abcabc
Explain joiner transformation in informatica