chandra sekhar


{ City } bangalore
< Country > india
* Profession * software engineer
User No # 65128
Total Questions Posted # 15
Total Answers Posted # 57

Total Answers Posted for My Questions # 45
Total Views for My Questions # 141431

Users Marked my Answers as Correct # 319
Users Marked my Answers as Wrong # 145
Questions / { chandra sekhar }
Questions Answers Category Views Company eMail

My source table having some records ,i want load 1st record and last record into one target?

iGate,

3 Informatica 8884

what is incremental aggregation ,with example?

 2 Informatica 8260

I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?

DELL,

8 Informatica 11655

How can you change from reusable session into non-reusable session.

Cap Gemini,

5 Informatica 40886

I want load the data into target with out 1st and last record.

Yash Technologies,

5 Informatica 8666

what is unit testing?tell me proceedure

L&T, UST,

Informatica 1880

Tell me one complex query in oracle ?

L&T, Satyam,

2 Informatica 7072

How to delete the data in the target table after loaded.

TCS,

3 Informatica 8188

How can you display only hidden files in UNIX

Cognizant, L&T,

4 Informatica 9262

How to delete the (flat file) data in the target table after loaded.

TCS,

2 Informatica 6905

What is the difference b/w natural key and surrogate key

 1 Informatica 4891

My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?

Cap Gemini,

3 Informatica 8907

what are the types of Data warehousing ?

 1 Informatica 2513

what are the types of facts with Examples?

 3 Informatica 5068

My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?

HP,

3 Informatica 8394



Answers / { chandra sekhar }

Question { PreVator, 40816 }

What is difference between TRUNCATE & DELETE?


Answer

Truncate Delete
1)it is DDl command it is DML command
2)it delete records permanently it delete records temporarly
we can't roll back we can roll back the data

Is This Answer Correct ?    1 Yes 0 No

Question { 11868 }

what is the use of uniq commmand?


Answer

simple it display the unique data in the file

Is This Answer Correct ?    0 Yes 0 No


Question { 8593 }

What is aggregate cache in aggregator transforamtion?


Answer

unsorted data loading into aggregate cache.

Is This Answer Correct ?    0 Yes 1 No

Question { 9786 }

In a sequential batch can you run the session if previous
session fails?


Answer

YES.
BUT If U GIVE ANY CONDITION LIKE $SESSION1.STATUS=SUCCEEDED,
IF THE SESSION1 SUCCEEDED THEN IT WILL RUN SESSION2 ,SUPPOSE SESSION1 FAILED THEN IT CAN'T RUN THE SESSION 2.

above example: if the session1 failed it can't run another session.if u can't give any condition it will run second session.

Is This Answer Correct ?    4 Yes 0 No

Question { 8326 }

What are reusable transformations in how many ways we can
create them?


Answer

Reusable Transformations are

1)Lookup t/r
2)stored procedure
3)sequence generator t/r

two ways we can create
1)Mapplet (multiple t/r)
2)Transformation devloper (single t/r)

Is This Answer Correct ?    0 Yes 2 No

Question { IBM, 47057 }

how to retrive only second row from table?


Answer

SQL> select * from (select rownum as rno,emp.* from emp)
2 where rno=&n;
Enter value for n: 2
old 2: where rno=&n
new 2: where rno=2

RNO EMPNO ENAME JOB MGR
HIREDATE SAL
---------- ---------- ---------- --------- ----------
--------- ----------
COMM DEPTNO
---------- ----------
2 7499 ALLEN SALESMAN 7698
20-FEB-81 1600
300 30

Is This Answer Correct ?    1 Yes 0 No

Question { 29510 }

what is dimension table?


Answer

Dimension table it consist master data and Non-numeric data

Is This Answer Correct ?    1 Yes 3 No

Question { UBS, 17609 }

how do u get the first record from 50,000 records ?


Answer

Select * from(select rownum as rno,emp.* from emp) where rno=&n
EX:

SQL> Select * from(select rownum as rno,emp.* from emp) where rno=&n;
Enter value for n: 1
old 1: Select * from(select rownum as rno,emp.* from emp) where rno=&n
new 1: Select * from(select rownum as rno,emp.* from emp) where rno=1

RNO EMPNO ENAME JOB MGR HIREDATE SAL
---------- ---------- ---------- --------- ---------- --------- ----------
COMM DEPTNO
---------- ----------
1 7369 SMITH CLERK 7902 17-DEC-80 800
20

Is This Answer Correct ?    0 Yes 2 No

Question { 9116 }

how to load duplicate row in a target


Answer

with out p.key in the target table we can load.

Is This Answer Correct ?    1 Yes 0 No

Question { 34177 }

what is upstream and downstream transformation?


Answer

above source qualifier upstream transformation and
expression is down stream transformation

Is This Answer Correct ?    4 Yes 3 No

Question { HSBC, 20383 }

we r using aggregator with out using groupby?


Answer

If you are using groupby the integration service produces
one row for each group, if you do not use groupby the
integration service returns one row(last row) for all input
rows.







chandumba2005@gmail.com

Is This Answer Correct ?    4 Yes 0 No

Question { HSBC, 7249 }

how to we create datamart?


Answer

Data mart is a subset of Data warehouse.it is a complete information about one particular domain.eg:(finance,sales).

Data marts and Data warehouses are built on dimensional
data modeling where the relationship b/w dimension tables fact tables.

Is This Answer Correct ?    0 Yes 0 No

Question { 16838 }

how will you remove the duplicate records from flat file
without using sorter?


Answer

SD---S.Q----EXP t/r------TGT.

add two port in exp t/r.
one is variable port v_seq expression:seq+1
one output port o_seq expression:v_seq
required ports connect to target.

Is This Answer Correct ?    1 Yes 4 No

Question { 9540 }

How to retrieve last two days updated records?


Answer

by using date range.we can find latest date updated records.

Is This Answer Correct ?    0 Yes 0 No

Question { Infosys, 40274 }

How to list Top 10 salary, without using Rank Transmission?


Answer

write sql query in the source qualifier t/r

sql override

select * from(select dense_rank () over (order by sal desc
nulls last)as rnk,emp.* from emp)where rnk<=10;

Is This Answer Correct ?    0 Yes 3 No

 [1]   2   3   4    Next