1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

if the column name in sql override is diff from the column name in source qualifier,what is the impact?

Question Posted / suman

Answer Posted / suman

if the coloumn name is different in sql override and in the
source qualifier it throws the error invalid identifier

Is This Answer Correct ?    0 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the differences between oltp and olap?

542

What are the different lookup cache(s)?

612

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1571

Differentiate between joiner and lookup transformation?

605

What are active and passive transformations?

642




5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1395

What is a dimensional model?

573

How to load the data from people soft hrm to people soft erm using informatica?

551

hi real timers . iam waiting for ur reply regarding ETL TESTING

1793

What is a sequence generator transformation?

563

How we can create indexes after completing the load process?

605

whats the logic to load the lower level of granularity of data to fact table.

1789

What are the types of schemas we have in data warehouse and what are the difference between them?

512

Is there any way to read the ms excel datas directly into informatica?

541

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2313