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 |
What is factless fact schema?
Have you worked with/created Parameter file
what is the Default Source Option For Update Strategy Transformation?
Which gives the more performance when compare to fixed width and delimited file ? and why?
Describe data concatenation?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
what is the drillup & drill down?and use of the drill up and drill down?
How to eliminate 1st and last rows from the source and load the inbetween rows.
what is the diff b/w union and joiner and lookup?
we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.