Interested to Buy Any Domain ? << Click Here >> for more details...
how can you load data into target table without leading zeor's
- 4 Answers
- 24927 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 |
When the informatica server marks that a batch is failed?
i have 2 flat files one table contains duplicates another one no duplicates.... so i need like this i don't want duplicates...pl's give me ans...
how to join the 2 different table with different columns in informatica?
what is the difference between Informatica 7.1 and Abinitio?
how we load the data from source to staging area
What do you mean by filter transformation?
What is the difference b/w natural key and surrogate key
I am using Informatica 7.1.1. and i used emails task for getting emails but not able to get emails is there any settings in Informatica installation level?
Briefly explain the aggregator transformation?
How we can create indexes after completing the loan process?
For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL
How you count the number of records available at your source?
Teradata 
