Normal (Default) Master outer Detail outer Full outer

ravi ranjan

• Jul 22nd, 2016

Joiner transformation having four types
1 Normal join
2 Master outer join
3 Detail outer join
4 Full join

Kiran Ghatage

• Nov 15th, 2014

Look into following mappings
https://community.informatica.com/solutions/developer_client_full_outer_join

https://community.informatica.com/solutions/developer_client_self_join_using_joiner

Answer Question  Select Best Answer

Type1: Rows containing changes to existing dimensions are updated in the target by overwriting the existing dimension. In the Type 1 Dimension mapping, all rows contain current dimension data. Use the Type 1 Dimension mapping to update a slowly changing dimension table when you do not need to keep any previous versions of dimensions in the table. Type 2: The Type 2 Dimension Data mapping inserts both...

ASHOK1324

 Profile Answers by ASHOK1324 Questions by ASHOK1324

• Apr 21st, 2009

The Dimensions are classified 3 types.
1.SCD TYPE1 (Slowly Changing Dimension) : contains current data.
2.SCD TYPE2 (Slowly Changing Dimension) : contains current data + complete
historical data.
3.SCD TYPE3 (Slowly Changing Dimension) : contains current data + recent
historical data.

Rp

• Oct 4th, 2007

SCD: Source to SQ - 1 mapping, SQ to LKP - 2 mapping, SQ_LKP to EXP - 3 Mapping, EXP to FTR - 4 Mapping, FTR to UPD - 5 Mapping, UPD to TGT - 6 Mapping, SQGen to TGT - 7 Mapping. I thin...

Answer Question  Select Best Answer

ramsetty

 Profile Answers by ramsetty Questions by ramsetty

• Jun 17th, 2009

Data profiling is a technique used to analyze the content, quality, and structure of source data. Use PowerCenter Data Profiling to detect patterns and exceptions of source data during mapping develop...

vizaik

 Profile Answers by vizaik Questions by vizaik

• Mar 24th, 2007

go to source analyzerimport databasesgo to warehouse designerimport databases (target definitions) else create using generate sqlgo to mapping designerdrag and drop sources and targets definitionslink ports properlysave to repositorythan q

Answer Question  Select Best Answer

Amit Gaikwad

• Jul 26th, 2012

Step 1: Go to session , and in treat source rows as :UPDATE
step2: in target table option select INSERT and UPDATE ELSE INSERT :)
Step 3:Refresh and Run the session .

nagadurgaraju

 Profile Answers by nagadurgaraju Questions by nagadurgaraju

• Sep 1st, 2010

By using source qualifier transformation to update tha target table,through SQL overriding...

Answer Question  Select Best Answer

Can any one tell me the option between the two session . if previous session execute successfully than run the next session...

vizaik

 Profile Answers by vizaik Questions by vizaik

• Mar 24th, 2007

you can drag and drop more than one session in a workflow.there will be linking different and issequential linkingconcurrent linkingin sequential linking, you can run which ever session you require or...

chsrikanth15

• Mar 2nd, 2007

Where exactly do we need to use?this link condition (id $ PrevTaskStatus = SUCCESSFULL)

Answer Question  Select Best Answer

What is the Technical reason for having Source Qualifier in Informatica? Can a mapping be implemented without it? (Please don't mention the functionality of SQ) but the main reason why a mapping can't do without it...

manojrana

 Profile Answers by manojrana Questions by manojrana

• Apr 7th, 2010

The most important significance of source qualifier is that it converts the datatypes (coming from a source) into informatica compatible datatypes.Rest all properties like distinct, overide, filtering records can be achieved by other transformations of informatica as well.

chandra Bose

• Sep 4th, 2007

In informatica source qualifier acts as a staging area, and it?will create?its own?data types which are related to source data types

Answer Question  Select Best Answer

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Jul 9th, 2012

Hi, One way of getting only the duplicate columns loaded in the target table is to modify the SQ query: When primary keys are defined: select * from where exists (select PK1,PK2,... from group b...

koustav

• Jul 31st, 2007

I think you can write the sql query (delete from....) in session post-sql command and it will work good.

Answer Question  Select Best Answer

sithu

 Profile Answers by sithu Questions by sithu

• Mar 24th, 2007

Event wait: will hold the workflow until it is get other instruction or delay mentioned by the userCheers,Sithusithusithu@hotmail.com

sanghala

 Profile Answers by sanghala Questions by sanghala

• Mar 9th, 2007

Event Wait task is a file watcher.when ever a trigger file is touched/created, this task will kick off the rest of the sessions to execute which are there in the batch.I used only User defined Event wait task.

Answer Question  Select Best Answer

srinivas1984

 Profile Answers by srinivas1984 Questions by srinivas1984

• Jan 11th, 2009

It is used to join two are more star schemas.

bharath

• Mar 2nd, 2007

It is also called as fixed dimension.It is a dimension which doesnot effect with respect to time.for example if the name of the city is changed from bombay to mumbai,the name will not change from time...

Answer Question  Select Best Answer

samirdesai999

 Profile Answers by samirdesai999 Questions by samirdesai999

• Jun 9th, 2009

Use sequence generator and filter there after with the condition< 100.

dl_mstr

 Profile Answers by dl_mstr Questions by dl_mstr

• Dec 30th, 2007

Use a sequence generator set  properties as reset and then use filter, put condition as NEXTVAL<=100 .

Answer Question  Select Best Answer

Neeraj

• Nov 7th, 2006

You can write the query as follows.SQL> select * from 2 (select ename,sal from emp order by sal desc) 3 where rownum

prasad

• Apr 27th, 2006

 the following is the query to find out the top three salariesin ORACLE:--(take emp table)select * from emp e where 3>(select count (*) from emp where e.sal>emp.sal) order by sal desc.in SQL Server:-(take emp table)select top 10 sal from emp

Answer Question  Select Best Answer

Racp238

 Profile Answers by Racp238 Questions by Racp238

• Apr 3rd, 2008

Why not just use an inline select statement in your sql qualifier to eliminat the overhead of a lookup transformation all together?

Vani_AT

 Profile Answers by Vani_AT Questions by Vani_AT

• Apr 3rd, 2008

Connected and Unconnected lookups have their own pros and cons.Unconnected lookup is designed for a specific purpose.The task that an unconnected lookup does can be done by a connected lookup also. Th...

Answer Question  Select Best Answer

prasadns26

 Profile Answers by prasadns26 Questions by prasadns26

• Jul 18th, 2006

hi,what ever my friends have answered earlier is correct. to be more specific,if the two tables are relational, then u can use the SQL lookup over ride option to join the two tables in the lookup prop...

rajendar

• Feb 12th, 2006

join the two source by using the joiner transformation and then apply a look up on the resaulting table

Answer Question  Select Best Answer

Adil M

• Jul 4th, 2007

De-normalization is basically the concept of keeping all the dimension hierarchies in a single dimensions tables. This causes less number of joins while retriving data from dimensions and hence faster data retrival. This is why dimensions in OLAP systems are de-normalized.

Stephen Ross

• Mar 29th, 2007

I am a beginner to DW, but as I know fact tables - DenormalizedAnd Dimension Tables - Normalized.If I am wrong, please correct.

Answer Question  Select Best Answer

Can anyone explain all the 4 partitions in Informatica and on which table what partition is used?2.Suppose we have 4 columns in a table primary key, 2 string columns and a numeric column? While doing a group by aggregation. what is the order that we have to group by?Thanks,Arpita.

Kevin

• Jul 19th, 2023

Database partitioning. The PowerCenter Integration Service queries the IBM DB2 or Oracle system for table partition information. It reads partitioned data from the corresponding nodes in the database....

rajesh_kare

 Profile Answers by rajesh_kare Questions by rajesh_kare

• Oct 21st, 2010

You can define following partition types in workflow manager.1) Database PartitioningThe Integration Service queries the IBM DB2 or Oracle system for table partition information. It reads partitioned ...

Answer Question  Select Best Answer

saiteja

• Jul 2nd, 2017

Rank is an active and connected transformation rank transformation contain inputport, outputport, variableport, rankport by using rank transformation we can get top (or) bottom ranks
rank transformation

arun singh

• Mar 8th, 2017

Use rank transformation to return top or bottom N-no of position, it uses rank cache to perform rank. In rank cache it contains both index as well as data cache. Index cache contains GROUP BY parts, w...

Answer Question  Select Best Answer

mootati raghavendroa reddy

• Jun 23rd, 2006

To eliminate the duplicate in flatfiles, we have distinct property in sorter transformation. If we enable that property, automatically it will remove duplicate rows in flatfiles.

sai

• Jun 13th, 2006

Hiusing Sorter Transformation we can eliminate the Duplicate Rows from Flat fileThanksN.Sai

Answer Question  Select Best Answer

When i was running workflow manager i.e, when i right click the task icon and clicking start workflow from task, i am getting a message like 'cannot connect to the server'. Can any body guide me, how to get the output.Thanks

libinjose

 Profile Answers by libinjose Questions by libinjose

• Apr 2nd, 2010

In that case you may query the fields from below Informatica repository tables and populate into your target tables. REP_WFLOW_RUN (WORKFLOW_NAME, RUN_ERR_MSG, RUN_STATUS_CODE) REP_TASK_INST_RUN(INSTA...

gargnakul

 Profile Answers by gargnakul Questions by gargnakul

• Feb 14th, 2007

Hi ,Can anybody please help me in case i want to store values of workflow monitor in target table .Like suppose if i run any workflow and check the status in workflow monitor.Now my requirement is tha...

Answer Question  Select Best Answer

Hanu Ch Rao

• Mar 2nd, 2007

I was asked this question in an interview,Where did you implement SCD2 and what was the transformations used.What was the complex transformations did you use.Answers please........?u can implement SCD...

sreedhark26

 Profile Answers by sreedhark26 Questions by sreedhark26

• Jan 9th, 2007

SCD IS USING FOR MAINTAIN HISTORICAL DATA AND CURRENT DATAEX: EMP TABLE WE CAN MAINTAIN CUSTOMER ADDRESS, AFTER ONE YEAR CUSTOMER ADDRESS IS CHANGED. SCD MAINTAINS CURRENT ADDRESS AND OLD ADDRESS ALSO...

Answer Question  Select Best Answer

dl_mstr

 Profile Answers by dl_mstr Questions by dl_mstr

• Feb 10th, 2008

when data from a single source needs to be loaded into multiple targets And multiple target has primary foreign key relation constraint based loading is used For example :  In the first ...

Phani

• Feb 16th, 2007

Hi,when data from a single source needs to be loaded into multiple targets, in that situation we use constraint based load ordering.Note: The target tables must have primary - foreign key relationships.regards,Phani...

Answer Question  Select Best Answer