Answer Posted / abinitiofreak
we have to use firstname||lastname expression
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
whats the logic to load the lower level of granularity of data to fact table.
How an expression transformation differs from aggregator transformation?
What is the need for an etl tool?
How does a sorter cache works?
Define sessions in informatica etl?
Explain the aggregator transformation?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Explain how many types of dimensions are available in informatica?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Define update strategy?
Under what condition selecting sorted input in aggregator may fail the session?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What are the types of caches in lookup? Explain them.
What are the static cache and dynamic cache in informatica?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?