Tuesday, February 24, 2015

Getting Count For Duplicate Values And Distinct Value

Getting Count For Duplicate Values And Distinct Value?

STEP 1:-
create table t1(t1 VARCHAR2(5),C2 VARCHAR2(5),C3 VARCHAR2(5));
create table t2(t1 VARCHAR2(5),C2 VARCHAR2(5),C3 VARCHAR2(5),C4 VARCHAR2(10));

INSERT INTO t1 values('a','b','c');
INSERT INTO t1 values('a','b','c');
INSERT INTO t1 values('x','y','z');
INSERT INTO t1 values('x','y','z');
INSERT INTO t1 values('a','s','d');
INSERT INTO t1 values('z','x','c');
INSERT INTO t1 values('v','b','n');
INSERT INTO t1 values('v','b','n');
INSERT INTO t1 values('q','w','e');
INSERT INTO t1 values('x','c','v');
COMMIT;

STEP:2

Monday, February 16, 2015

Assigning a Batch Number Using Sequence Generator

In my case i have scenario ..

batch_num column assign a values group of 1000

In case i used a sq transformation and mod function in Informatica expression transformation.

Or We can do it from different ways....:)

Wednesday, January 21, 2015

Path of infa variable stored in admin console ...

Monday, December 22, 2014

The workflow [xxxxxx] failed because an operating system profile was not specified and the Integration Service uses operating system profiles. Please check the Integration Service log for more information.

The workflow [xxxxxx] failed because an operating system profile was not specified and the
Integration Service uses operating system profiles. Please check the Integration Service log for more information.

I had faced this issue,now i am going to explain wht i did to resolve this.