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

pallavi

• Nov 29th, 2006

Dynamic lookup cache is used in case of connected lookups only, It is also called as read and write cache, when a new record is inserted into the target table, then cache is also updated with the new ...

rma

• Nov 24th, 2006

Dynamic Lookup generally used for connect lkp transformation, when the data is cgenged then is updating, insert or its leave without changing .....

Answer Question  Select Best Answer

jayapraveen

 Profile Answers by jayapraveen Questions by jayapraveen

• Oct 12th, 2010

In a banking project if we are dealing with a Customer information ModuleThen we require4 dimensions7 Fact tablesminimum of 45 mappings requiredsize of Database is 9GB required

Whatever

• Mar 19th, 2007

Exactly 93.133

Answer Question  Select Best Answer

akmohanty

 Profile Answers by akmohanty Questions by akmohanty

• Feb 14th, 2007

Staging database is the storage area of data. it does cleans the data, transform,combine and prepare the source data to the data mart area or data ware house.

manju

• Jan 12th, 2007

Staging database is the storage area. it clean the data, transform,combine and prepare  the source data to the data mart or data ware house. staging area is in b/w the source database  ...

Answer Question  Select Best Answer

sathish

• Apr 6th, 2007

Ok we will refer development document , Could you teach me how to write test cases for unit testing in development document before development and give me an example to sample test cases.

Gopalakrishnan Kannan

• Dec 21st, 2006

Hi,To test the mapping, 1. Prepare mapping document. This mapping document explains start to finish of the entire transaction. This document shld contains each column level transformation logic from s...

Answer Question  Select Best Answer

dl_mstr

 Profile Answers by dl_mstr Questions by dl_mstr

• Feb 10th, 2008

To check data loaded in the backend can be done by collecting the session results from the reposistory tablesquality of dataloaded can be done by writing sql qureries on the target table.To Check perf...

tomtwj

 Profile Answers by tomtwj Questions by tomtwj

• Mar 14th, 2007

Performance, Data quality, consistensy and exception handling, large various source types.  

Answer Question  Select Best Answer

kanak3

 Profile Answers by kanak3 Questions by kanak3

• Mar 27th, 2007

Pal....We can not use charcode() function here.When you configure the PowerCenter Server to run in ASCII mode, CHRCODE returns thenumeric ASCII value of the first character of the string passed to the...

pal

• Mar 6th, 2007

Use chrcode().

Answer Question  Select Best Answer

sridhar39

 Profile Answers by sridhar39 Questions by sridhar39

• Dec 29th, 2007

hi      PMCMD means program command line utility.       it is a program command line utility to communicate with informatica server.  &...

chandrarekha

• Sep 28th, 2007

It a command line program. It performs the following tasksStart and stop the session and batchesStop the Informatica ServerChecks whether the server is working or not

Answer Question  Select Best Answer

Rajarao marisa

• May 31st, 2012

Ok its not good work environment by using multiple filter t/r usage Any way by using multiple filter we can load rejected rows also SD-->SQ-->fltr(condition(true)(eg:deptno=10)---->loaded into one tar...

srinuraj

 Profile Answers by srinuraj Questions by srinuraj

• May 31st, 2010

You can use filter transformations to filter rows. Filter transformations passes rows to next transformation which rows met the condition. But it cannot pass rows which rows doesn't meet the condition...

Answer Question  Select Best Answer

prashant.baranwal

 Profile Answers by prashant.baranwal Questions by prashant.baranwal

• Sep 19th, 2010

What is one disadvantage of using an unconnected (sometimes called function mode) Lookup transformation? (1) If there is no match in the Lookup condition, the Informatica server returns a transformati...

vivek.gce

 Profile Answers by vivek.gce Questions by vivek.gce

• Oct 16th, 2008

If there is no match in the Lookup condition, the Informatica server returns a transformation error.

Answer Question  Select Best Answer