A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT
APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?
Answer Posted / abidu
Write 'not applicable' as the default in the expression
transformation.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Explain direct and indirect flat file loading (source file type) - informatica
Do you find any difficulty while working with flat files as source and target?
Plz can any one say me how to get the informatica certification materials and dumps
difference between repository database and repository service?
Design a mapping to load the cumulative sum of salaries of employees into target table?
Does an informatica transformation support only aggregate expressions?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is the benefit of partitioning a session?
How to do the error handling of if ur source is flatfiles?
Differentiate between reusable transformation and mapplet.
How can we update a record in the target table without using update strategy?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
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.
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What are the different components of powercenter?