Interested to Buy Any Domain ? << Click Here >> for more details...
how can you load data into target table without leading zeor's
- 4 Answers
- 24774 Views
- Deloitte, I also Faced
- E-Mail Answers
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 do you change a non-reusable transformation to reusable transformation?
Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.
What is rank index in rank transformation?
What are the associated ports in look up T/R.
i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task
what is the difference between informatica6.1 and infomatica7.1
A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?
what are factless facts? And in which scenario will you use such kinds of fact tables.
how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z
How can you generate reports in informatica?
how to join the 2 different table with different columns in informatica?
Explain scd type 3 through mapping.
Teradata 
