can we see the data in fixed width file? how can u change
the datatype of fixed width files?
Answer / venkat
in seq file field width option is there we can change datatype and length
Is This Answer Correct ? | 0 Yes | 1 No |
country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?
plz tell me some dimentional and fact table names in banking project?
Give example for FACTLESS FACT TABLE in real-time scenario.
What is RCP
What are the different type of jobs in datastage?
3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000
Explain the importance of surrogate key in data warehousing?
souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2
i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me i don't need "_"ex nnnxx this type i want
how many dimentions and fact tables used in your project and what are names of it?
How to Remove Duplicate using SQL?
how can i get 2nd highest salary in datastage?can u send me ,thanQ 2)if i had source has 2 records 1st record ie 1st column contains 1,2,3 and 2nd coulmn contains 10,10,10 i have to get target as 2nd columns as 20,30,40 how can i?