how can you load data into target table without leading zeor's
- 4 Answers
- 23690 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is dimensional table?
Suppose we do not group by on any ports of the aggregator what will be the output?
How to configure mapping in informatica?
What are the limitations of joiner transformation?
What is enterprise data warehousing?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is the different lookup cache(s)?
What are the transformations that are not supported in mapplet?
How to improve the performance of a session using sorter transformation?
What is the procedure for creating independent data marts from informatica 7.1?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
In warehouses how many schemas are there?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Explain lookup transformation source types in informatica
Do you find any difficulty while working with flat files as source and target?
