sai

• Feb 14th, 2007

Hi here is the answer
select * from t_name where rowid in (select rowid from t_name group by empno having count(*) =3);

chandra_rn

• Feb 7th, 2007

I think this is query select * from emp where rowid > select max(rowid) from emp group by eno,ename

Answer Question  Select Best Answer

dl_mstr

 Profile Answers by dl_mstr Questions by dl_mstr

• Feb 10th, 2008

By default when we create the session, workflow creates pass-through partition points at Source Qualifier transformations and target instances.  Partition points mark the thread boundaries in...

sreedhark26

 Profile Answers by sreedhark26 Questions by sreedhark26

• Mar 12th, 2007

When you create or edit a session, you can change the partitioning information for each pipeline in a mapping. If the mapping contains multiple pipelines, you can specify multiple partitions in some p...

Answer Question  Select Best Answer

dl_mstr

 Profile Answers by dl_mstr Questions by dl_mstr

• Feb 10th, 2008

If the recover option is not set and 10,000 records are committed then delete the record from the target table using audit fields like update_date.

vizaik

 Profile Answers by vizaik Questions by vizaik

• Mar 25th, 2007

when ever session fails, then we have to follow these steps:if no commit is performed by the informatica server, then run session again.if at least one commit is performed by the session, recover...

Answer Question  Select Best Answer

senthilkar

 Profile Answers by senthilkar Questions by senthilkar

• Dec 17th, 2007

If the sources are homogenous, we use source qualifierif the sources have same structure we can use union transformation

chandrarekha

• Sep 24th, 2007

You can join two tables with in the same database by using lookup query override

Answer Question  Select Best Answer

Sujaya

• Sep 3rd, 2007

There is no default group in Filter Transformation. The records which does not satisfy filter condition are discarded and not written to reject file or session log file

babu

• Jul 11th, 2007

The rows which are not satisfing the filter transformation are discarded. It does not appear in the session logfile or reject files.

Answer Question  Select Best Answer

hanimi

 Profile Answers by hanimi Questions by hanimi

• Dec 1st, 2010

Using snow flake schema.

Anindya1281

 Profile Answers by Anindya1281 Questions by Anindya1281

• May 2nd, 2010

This can be done using str --> exp --> Agg --> exp --> targetsay src file:port1 port2A1    B1A1    B2A1    B3A2    B1A2 &nb...

Answer Question  Select Best Answer

Adil M

• Jul 10th, 2007

This is because we cannot use a Non Reusable Sequence Generator Transformation in a mapplet. Hence we must use a Re usable Sequence Generator. The fact that we reuse mapplets has no bearing over why we should use a reusable SG.

madarapu

 Profile Answers by madarapu Questions by madarapu

• Jul 3rd, 2007

Since mapplet is to reusability so if we include  a sequence generator inside a mapplet.the mapplet which we r going to reuse it for next time the sequence generator properties would be changed.so that we can not recommend it inside a mapplet which gives inproper result set.

Answer Question  Select Best Answer

Can we use LEFT OUTER JOIN (ANSI SQL standard) in SQ query override with SAMPLE key word?(help me my dba used same in a mapping which have 5 rel SRCS from a single db and contain expression -- directed to TGT)

N SRIRAM K

 Profile Answers by N SRIRAM K Questions by N SRIRAM K

• Sep 7th, 2007

Adding to Mr. Sriram Kumar, As per the investigation I did with SAMPLE keyword in SQ trans......and fortunately its working.............Thx

Sriram Kumar N

• Aug 10th, 2007

You can use LEFT OUTER JOIN or RIGHT OUTER JOINS in source qualifier trans as SQL override. But make sure that you are not combining two or more outer joins using the same table as the inner table of more than one outer join.More information reach me @ sriram . kumar @ oneindia . in

Answer Question  Select Best Answer

sheeladere

 Profile Answers by sheeladere Questions by sheeladere

• Dec 30th, 2009

If you want to directly get the records from some relational table then you can use the query in Source qualifier to group by on all the columns and get the count of records and pass the records which...

sanjeev

• Aug 6th, 2007

If you take a ex:EMP TABLE? having the duplicate recordsThe query isSELECT *FROM EMP WHERE EMPNO IN SELECT EMPNO FROM EMP GROUP BY EMPNO HAVING COUNT(*)>1;Sanjeeva Reddy

Answer Question  Select Best Answer

venu adavelly

• Sep 17th, 2007

We can get multiple values from unconnected lookup return port using conncatination logic, then we have to split the values to respect columns?Do you need more information call 9833705604venu adavelly?

kavit gupta

• Aug 23rd, 2007

It s not possible to return more than one value using unconnected lookup. You can not opt more than one return (R) port in unconnected lookup.

Answer Question  Select Best Answer

chillkrishna

 Profile Answers by chillkrishna Questions by chillkrishna

• Oct 11th, 2009

Size of the datamart completely based on your client requirements. BA's & DBA's basically decide datamart size.Hope this helps.Krishna M

Thananjayan

 Profile Answers by Thananjayan Questions by Thananjayan

• Dec 6th, 2007

Hi,Data mart is a part of the data warehouse.for example In an organization we can manage Employee personal information as one data mart and Project information as one data mart,one data ware house ma...

Answer Question  Select Best Answer

What is use of UNIX in Informatica? Where and how can we use UNIX shell scripts or commands to run informatica jobs or other related applications in informatica?Please tell in details as i am working on windows environment, but will be shifted to UNIX environment. Please describe in details starting from installation of informatica in UNIX to run or guide the working on informatica in Unix environment.

Amit Tarafder

• Feb 16th, 2017

Informatica is installed on Unix servers. Unix is used to run different shell scripts in server environment through
Informatica command tasks.

sriluck

• Sep 24th, 2007

HiThese are some ways unix works with Informatica.1) In unix box, we can create a SCRIPT which calls informatica session  and make the session run.2) We can UPDATE STATISTICS or CLEANUP files by ...

Answer Question  Select Best Answer

vivekvish

 Profile Answers by vivekvish Questions by vivekvish

• Jul 24th, 2008

You would use Normal Loading when the target table is indexed and you would use bulk loading when the target table is not indexed. Running Bulk Load in an indexed table will cause the session to fail.

chandrarekha

• Sep 28th, 2007

Normal Load: It loads the records one by one, Server writes log file for each record, So it takes more time to load the data.Bulk load : It loads the number of records at a time, it does not write any log files or tracing levels, so it takes less time.

Answer Question  Select Best Answer

I have to load data from DB2 flat file to MS SQL Server target tables.

nitin_2002786

 Profile Answers by nitin_2002786 Questions by nitin_2002786

• Jan 24th, 2013

First for Flat file a connection is not required.
All we need to provide is the path of the path in the mapping properties.

Anil Borru

• May 28th, 2012

It will save in Informatica Server below path:

c:Informatica9.0.1serverinfa_sharedSrcFiles

Answer Question  Select Best Answer

Amritendra kumar

 Profile Answers by Amritendra kumar Questions by Amritendra kumar

• Feb 29th, 2008

Unconnected lookup only return 1 port but if you want to return 2 port then u have to play mind game mean u hav to use concatenate operator in expression editor.

Thananjayan

 Profile Answers by Thananjayan Questions by Thananjayan

• Dec 6th, 2007

Unconnected look up can't return more than one value.

Answer Question  Select Best Answer

kvrp461

 Profile Answers by kvrp461 Questions by kvrp461

• Aug 13th, 2010

In SCD Type2 we want to maintain the historical as well as current data.By using surrogate key or sequence generated key to maintain this historical data on to the target tables.

Thananjayan

 Profile Answers by Thananjayan Questions by Thananjayan

• Nov 17th, 2007

You can maintain the historical data by desing the mapping using Slowly changing dimensions types.If you need to insert new and update old data,best go for Update strategy.If you need to maintain the ...

Answer Question  Select Best Answer

roshan239

 Profile Answers by roshan239 Questions by roshan239

• Jul 19th, 2010

You have asked a wrong question coz there is no concept constraint based commit.. It is constraint based ordering and target load plan which is for user to differentiate where data is t...

chandumedum

 Profile Answers by chandumedum Questions by chandumedum

• Jan 25th, 2008

CBL means constaraint based loading.the data was loaded into the the target table based on the Constraints.i.e if we want to load the EMP&DEPT data,first it loads the data of DEPT then EMP because...

Answer Question  Select Best Answer

vizaik

 Profile Answers by vizaik Questions by vizaik

• Nov 14th, 2007

You can use the Repository Manager to perform the following tasks:Add or remove a repository.Work with repository connections. Search for repository objects or keywords.View object dependencies. Compa...

obli prabu KV

• Oct 28th, 2007

Using repository manager*We can create folders under the repository*Create Sub Folders and Folder Management*Create Users and USer Groups*Set Security/Access Privilges to the usersand many more... 

Answer Question  Select Best Answer

ggazulas

 Profile Answers by ggazulas Questions by ggazulas

• May 27th, 2008

You wont get an error if the row is inserted in dynamic cache and it was rejected in the target table. But remember we are refering to the same table in dynamic chache, so if it is inserted in the cha...

prakash

• Nov 26th, 2007

Data in the target table does syncronize. here you wont get any error but the result will not so accurate. so update it in the trg or you can use update strategy transformation as insert after lookup

Answer Question  Select Best Answer

ORAINFO

 Profile Answers by ORAINFO Questions by ORAINFO

• Nov 18th, 2008

Metadata means data about data. Metadata extension means any additional information about the data. For Example let us consider a source qualifier and then I want to put any extra info about it like d...

prabhat007

 Profile Answers by prabhat007 Questions by prabhat007

• Dec 8th, 2007

Metadata Extensions: Who created,what purpose,version number etc for future enhancements. Information about mapping for other people to better understand.Metadata information in repository can be reported using informatica metadata tool.

Answer Question  Select Best Answer