Hi
I am getting 4 digit number from the flat file in one of the column. But how to show always 8 digit number even we get 2 or 3 or 4 digit number.
I have to show 8 digit number in my target table. Can anybody suggest how to achieve this!!
Regards
Quote from: anjidwh.cognos on 30 Apr 2014 12:47:37 AM
Hi
I am getting 4 digit number from the flat file in one of the column. But how to show always 8 digit number even we get 2 or 3 or 4 digit number.
I have to show 8 digit number in my target table. Can anybody suggest how to achieve this!!
Regards
What do you mean by "show 8 digit number"? You are writing data to the table, not displaying it? If the column in your target table is defined as a numeric data type it makes no difference whether it is one digit or 8 passing through your build - it will be stored as a number. Can you explain further?
MF.
From the file we are had data for one of the column like below:
customer number
---------------------
00001020
25361523
00001253
Here my question is while I am extraction file into build and write a simple select stmt for file, then values are shown like this.
customer number
---------------------
1020
25361523
1253
But I need complete 8 digit number how the file contains into my build also. Please help me to get out of this.
Regards
Quote from: anjidwh.cognos on 01 May 2014 12:54:10 AM
From the file we are had data for one of the column like below:
customer number
---------------------
00001020
25361523
00001253
Here my question is while I am extraction file into build and write a simple select stmt for file, then values are shown like this.
customer number
---------------------
1020
25361523
1253
But I need complete 8 digit number how the file contains into my build also. Please help me to get out of this.
Regards
What is the data type of the column defined as in your text file definition in Data Manager? is it a number of some sort or a char of some sort? How do you want it to be stored in the table you are writing to?
MF.